set define off;

INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'FILE_TRANSFER_MODE','ALL','Passive','Indicates the mode in which we would like to perform file transfer');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PRIORITY_USER_NAME','asc.prcServer','root','Identifies the priority user for performing ftp/sftp login to remote device');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'CLIENT_DRV_COMMAND','asc.prcServer','~insite/bin/clientdrv','The location of the client drv command');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'CLIENT_DRV_GREETING_WAIT','asc.prcServer','3','Default wait time for the greetings message');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'REXEC_MODE','asc.prcServer','Passive','The mode to use for rexec commands');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ASC_MOUNT_POINT','ALL','/ascpdata3/','The autosc mount point location');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SWEEP_SCRIPT_DIR_LOCATION','asc.prcServer','sweeps/','Location of sweep scripts');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ASC_DIR_SEPERATOR','ALL','/','Autosc Directory seperator to use');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'JOBDIRS_LOCATION','ALL','/jobdirs/','Location of jobdirs');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'DATAPOOL_LOCATION','ALL','/datapool/','Location of datapool Dir');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'LOAD_PROPERTY_REFRESH_RATE_IN_MS','ALL','3600000','Specifies the refresh rate for the properties');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ERRMSG_UNKNOWN_HOSTNAME','ALL','Unable To Set Host Name for Execution Server','Error message for unknown host name');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ERRMSG_TASK_ID_IS_NULL','ALL','TaskInfo Task ID was found to be null - Invalid Request State','Error messgae when task id is null');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAIL_DEFAULT_SMTP_HOST','ALL','amermsx.med.ge.com','Smtp host name');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAIL_DEFAULT_SENDER','ALL','autosc@med.ge.com','From email address');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAIL_INVALID_ADDRESS_CHARS','asc.prcServer','()','Invalid email address characters');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAIL_MAX_KBYTES','asc.prcServer','2765','Maximum size of the mail');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAIL_HEADER_COMMENT_TO','asc.prcServer','http\://supportcentral.ge.com/products/sup_products.asp?prod_id\=15648','Mail header comment to');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'MAX_PRC_LOOKUP_FAIL_COUNT','asc.loadBalancer','10','Max failure counts for process server. Used by load balancer');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'LBS_SCHEDULED_ADJUST','asc.loadBalancer','600000','Scheduled adjust for load balancer');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'LBS_READY_QUEUE_MULTIPLIER','asc.loadBalancer','10','Queue Multiplier for LBS Ready Queue');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPSWEEP_TIMEOUT','asc.prcServer','120000','Default timeout to sue by IPSweep');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'CLIENTDRV_PING_TIME_IN_SEC','asc.prcServer','30','Client Drv Heartbeat time in milliseconds');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_STATUS_REPORT_FILE_NAME','ALL','iipStatusReport.xml','predefined name for the onwatch status report');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_SCRIPT_DIR_LOCATION','ALL','Onwatch/','predefined name for the onwatch directory');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_TASKLIST_DOCTYPE','ALL','<!DOCTYPE taskList SYSTEM "TaskList.dtd">','Document type that is put to the first line of taskList.xml');

--Dummy Task
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'DUMMY_TASK_SLEEP_TIME','asc.prcServer','52','Default sleep time for summy task');

--Dispatcher
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PRIORITY_SCHEDULED_ADJUST','ALL','50','Amount of Time to Schedule between objects that are moved to schedule queue because of priority limit');

-- On Watch Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_DEFAULT_USER','asc.prcServer','insite','Default user to use for running iip_wake up command');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_DEFAULT_TIMEOUT','asc.prcServer','60000','Time to wait to receive a response for iip wake up command');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_DEFAULT_COMMAND','asc.prcServer','~insite/bin/iip_wakeup','Location of iip wake up script');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_POLL_MARGIN_MINS','asc.scheduler','30','Margin to wait if the device misses its next promised poll, meybe there are network isssues on the device');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_MARGIN_AFTER_SUCCESS_MINS','asc.scheduler','300','Time to wait before closing the task for which onwatch wakeup was success. May be we are uploading a very huge file');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_TASK_TYPE_NAME','asc.scheduler','ONWATCH_WAKEUP','OnWatch Wakeup task type name');

--Scheduler properties 
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'TASK_PRIORITY_LEVEL','ALL','5','Current Maximum Priority Level of tasks being processed by the system');

--Scheduler Max thread Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_TASK_MAX_THREADS','asc.scheduler','10','Maximum number of threads used for onwatch wakup task');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'READYQUEUE_CLEANUP_TASK_MAX_THREADS','asc.scheduler','5','Maximum number of threads used for ready queue cleanup task');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'DISPATCH_OBJECT_MAX_THREADS','asc.scheduler','10','Maximum number of threads used for scheduled object');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'DISPATCH_REQUEST_SCHEDULE_MAX_THREADS','asc.scheduler','10','Maximum number of threads used for request schedule');

-- PSS Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'VALID_EMAIL_PATTERN','asc.pssServer','^[a-zA-Z0-9-_.$]+[@][a-zA-Z0-9_.$]*ge.com$','Valid email pattern');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SSO_WS_URL','asc.pssServer','http://search.corporate.ge.com/ldq/Query?serverId=ssoProd&returnParameters=georaclehrid,mail,gehrindustrygroup,gehrbusinesssegment,cn&searchBase=ou=geWorker,o=ge.com&Prebuilt=true&scope=2&filter=(mail=<filter>)','Contains URL string to use to perform SSO Validation');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SSO_ALLOWED_GE_GROUPS.Technology Infrastructure - Healthcare','asc.pssServer','GE Technology Infrastructure','Contains comma delimited list of GE groups that are allowed to sweep systems');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SSO_ALLOWED_GE_GROUPS.Healthcare','asc.pssServer','GE Healthcare','Contains comma delimited list of GE groups that are allowed to sweep systems');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SSO_ALLOWED_GE_GROUPS.Healthcare - Staff','asc.pssServer','GE Healthcare','Contains comma delimited list of GE groups that are allowed to sweep systems');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SSO_ALLOWED_BUSINESS_SEGMENT','asc.pssServer','Technology Infrastructure - Healthcare,Healthcare,Healthcare - Staff','Contains comma delimited list of GE business segments allowed to sweep systems');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_EMAIL_SUBJECT','asc.pssServer','Sweep Request Report :','Subject message to be used for notify mail messages');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_FAILURE_EMAIL_SUBJECT','asc.pssServer','Sweep Request Failed!!!','Subject message to be used for notify mail messages if request has failed');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_NOTIFY_MAIL_HEADER_FILE','asc.pssServer','notifyMail.msg','File containing the notify mail header info');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_NOTIFY_MAIL_FOOTER_FILE','asc.pssServer','footer.msg','File containing the footer info');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_EMAIL_HOST_NAME','asc.pssServer','amermsx.med.ge.com','Smtp host name to be used for sending mails');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_EMAIL_FROM_ADDRESS','asc.pssServer','autosc@iscmed.olc.med.ge.com','The from email address to use');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_EXPIRATION_WARN_ADVANCE_DAYS','asc.pssServer','30','The number of days in advance pss needs to start sending notifications');

-- ASD Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PSS_WS_URL','ALL','http://olc-ppads-dev-01.am.health.ge.com:9601/asc-pssServer-web/services','The pss web service location');

-- IPTDS Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_WORKER_NUM','asc.prcServer','25','Number of IPTDS thread worker to handle IPTDS request');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_SERVER_PORT','asc.prcServer','7979','IPTDS listening port');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_SERVER_SOCKET_TIMEOUT','asc.prcServer','5000','IPTDS server socket timeout');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_CLIENT_SOCKET_TIMEOUT','asc.prcServer','120000','IPTDS client socket timeout');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_URGENT_WORKERS','asc.prcServer','1','Number of thread in the IPTDS thread pool being reserved for urgent request');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'IPTDS_SHUTDOWN_GRACE_PERIOD_IN_SEC','asc.prcServer','10','Grace period before IPTDS thread pool being forced stopped');

-- SHEM Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SHEMJOB_PROCESS_DATA_PASS','asc.pssServer','2','Number of pass for Shem process');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SHEM_TEAM','asc.pssServer','shemteam','The file where data can be dumped which will notify the shem team');

-- PPADS Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PPADS_ROOT_PROPERTY','asc.prcServer','/ascpdata3/data2/ppads','ppads home directory');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PPADS_SITES_DIR','asc.prcServer','sites','sites directory name');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PPADS_SITES_LOCK_FILE','asc.prcServer','.lockfile','file that is used to lock the site');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SITES_LOCKFILE_SLEEP_MSEC','asc.prcServer','5000','Time between attempt to create lockfile for the site directory');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SITES_LOCKFILE_MAX_RETRY','asc.prcServer','120','Maximum number of attempt to create lockfile for the site directory before failed out');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'SITES_LOCKFILE_STALE_SPAN_MIN','asc.prcServer','60','Time in minute the site lockfile leave untouched and is considered the lock become expired.');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'POST_PPADS_EVENT','asc.prcServer','/ascpdata3/data2/ppads/bin/postPpadsEvent','Full qualified path to postPpadsEvent command');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PPADS_ENV_LIST','asc.prcServer','PPADS_MOUNT=/ascpdata3/data2;ENVPROD=/ascpdata3/data2/ppads/envprod','semi-colon separated environmental variables that are called with ppads command');

-- Prodiags Properties
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PRODIAGS_SCHEDULE_REQUEST_TYPE_NAME','ALL','PRODIAGS.SCHEDULE_UPDATE','request name for update prodiags schedule');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PRODIAGS_TASK_TYPE_IDENTIFIER','ALL','TASK_TYPE','Identifier for recognize this is prodiags task type. This is use in sweep as well as command file');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PD_ADD_TASK','ALL','addTask','sweep task type identifier for prodiags add command.');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PD_INSTALL_TASK','ALL','InstallTask','sweep task type identifier for prodiags install command.');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PD_MODIFY_TASK','ALL','modifyTask','sweep task type identifier for prodiags modify command.');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PD_DELETE_TASK','ALL','deleteTask','sweep task type identifier for prodiags delete command.');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PD_UNINSTALL_TASK','ALL','unInstallTask','sweep task type identifier for prodiags uninstall command.');

-- Reloaders
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'RELOADABLE_CODE_NAMES','asc.loadBalancer','LBS_P_APP_001,LBS_P_APP_002','Code names which need to be reloaded on lbs restart');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'PRC_RELOADABLE_CODE_NAMES','asc.prcServer','PRC_P_APP_000','Code names which need to be reloaded on prc restart');

-- UnRegulated
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'UNREGULATED_TASK_CATEGORY_NAMES','ALL','GATHER,NOTIFY','Task Categories which are to be kept unregulated');

--Autosc IB Properties June 2010
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.cua','false','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.dispatcher','false','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.loadBalancer','false','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.scheduler','true','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.pssServer','true','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.prcServer','true','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'STEP_LOGS_ENABLED','asc.OnWatchReceiver','true','Property to enable/disable step logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'CONTACT_LOGS_ENABLED','asc.OnWatchReceiver','false','Property to enable/disable contact logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'CONTACT_LOGS_ENABLED','asc.prcServer','false','Property to enable/disable contact logging');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ASD_FILE_DELIVERY_WEB_SERVER_URL','asc.asd','http://autosc.am.health.ge.com/','The web server url where the file exists');
INSERT INTO AUTOSC.CFG_PROPERTIES(PROPERTY_ID,PROPERTY_NAME,STEP_TYPE,PROPERTY_VALUE,DESCRIPTION) VALUES (CFG_PROPERTIES_SEQ.nextVal,'ONWATCH_WAKEUP_MAX_WAIT_FOR_NEXT_POLL','asc.prcServer','1440','Max wait time in minutes for the next poll of the system to execute onwatch sweep');

COMMIT;

set define on;